<!--一门课程的总体展示  php部分实现数据库取课程通知-->

<?php
$connection =@mysqli_connect("localhost","root","root","educate");
if(!$connection){
    exit("<h1>数据库连接失败</h1>");
}
$sql = "select * from annocement_course ";
$result = mysqli_query($connection,$sql);

$get_course = $_GET['course'];  //存储get传过来的值
?>
<!doctype html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title></title>
    <meta name="robots" content="noindex, follow" />
    <meta name="description" content="">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <!-- Favicon -->
    <link rel="shortcut icon" type="image/x-icon" href="../assets/images/favicon.ico">


    <!-- Use the minified version files listed below for better performance and remove the files listed above -->
    <link rel="stylesheet" href="../assets/css/vendor/vendor.min.css">
    <link rel="stylesheet" href="../assets/css/plugins/plugins.min.css">
    <link rel="stylesheet" href="../assets/css/style.min.css">

</head>

<body>
    <div class="header-area header-three">
        <!-- Header Middle Start -->
        <div class="header-middle space-40 sticker" style="padding: 18px;">
            <div class="container">
                <div class="row align-items-center">
                    <div class="col-lg-3 col-6">
                        <div class="logo">
                            <a href="../index.php"><img src="../assets/images/logo/pos-circle-logo.jpg" alt=""
                                                        class="img-fluid"></a>
                        </div>
                    </div>
                    <div class="col-lg-9 col-6">
                        <div class="header-middle-inner">
                            <!-- Main Menu Start -->
                            <div class="header-menu float-left add-sticky">
                                <div class="sticky-container">
                                    <div class="logo">
                                        <a href="../index.php"><img src="../assets/images/logo/pos-circle-logo.jpg" alt=""
                                                                    class="img-fluid"></a>
                                    </div>
                                    <nav class="main-menu">
                                        <ul>
                                            <li>
                                                <a href="../index.php">首页<i></i></a>
                                            </li>
                                            <li>
                                                <a href="#">资源 <i class="fa fa-angle-down"></i></a>
                                                <div class="mega-menu dropdown">
                                                    <ul class="mega-menu-inner d-flex">
                                                        <li>
                                                            <a href="">环境搭建</a>
                                                            <ul>
                                                                <li><a href="http://www.mingw-w64.org/doku.php">MinGW-64-GCC</a></li>
                                                                <li><a href="https://www.python.org/">Python</a></li>
                                                                <li><a href="https://www.java.com/zh-CN/">Java</a></li>
                                                                <li><a href="https://www.anaconda.com/">Anacanda</a>
                                                                </li>
                                                            </ul>
                                                        </li>
                                                        <li>
                                                            <a href="">编译软件</a>
                                                            <ul>
                                                                <li><a href="https://www.codeblocks.org/">CodeBlocks</a></li>
                                                                <li><a href="https://www.jetbrains.com/pycharm/">Pycharm</a></li>
                                                                <li><a href="https://www.eclipse.org/downloads/">Eclipse</a></li>
                                                                <li><a href="https://code.visualstudio.com/">Visual Studio Code</a></li>
                                                            </ul>
                                                        </li>
                                                        <li>
                                                            <a href="">实用软件</a>
                                                            <ul>
                                                                <li><a href="404.html">Notpad++</a></li>
                                                                <li><a href="https://www.typora.io/">Typora</a></li>
                                                                <li><a href="http://www.sublimetext.com/3">Sublime Test</a></li>
                                                            </ul>
                                                        </li>
                                                    </ul>
                                                </div>
                                            </li>
                                            <li><a href="../notice/notice.html">课程公告</a></li>
                                            <li><a href="../competition/competition.php">竞赛公告</a></li>
                                            <li><a href="../about.html">平台介绍</a></li>
                                        </ul>
                                    </nav>
                                </div>
                            </div>
                            <!-- Main Menu End -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Header Middle End -->
    </div>



    <!--=====================
    Breadcrumb Aera Start
    =========================-->
    <div class="breadcrumbs_area">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="breadcrumb_content">
                        <ul>
                            <li>
                                <h1><a href="../index.php">首页</a></h1>
                            </li>
                            <li>大学计算机</li>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!--=====================
    Breadcrumb Aera End
    =========================-->

    <!--=====================
    Blog Grid Aera Start
    =========================-->
    <div class="blog-grid-area">
        <div class="container">
            <div class="row">
                <div class="col-lg-9 order-lg-2">
                    <div class="row mt-20 mb-20">
                        <div class="col-lg-6 col-md-6">
                            <!-- Single Blog Start -->
                            <div class="single-blog mt-30" style="margin-left: 30px;">
                                
                                <div class="blog-content">
                                    <h5 class="title"><a href="blog-details.html">课程介绍</a></h5>
                                    <ul class="meta">
                                        <li><i class="fa fa-calendar"></i><a href="#">July 1, 2021</a></li>
                                        <li><i class="fa fa-user-circle"></i> Posts by : 刘新平</li>
                                    </ul>
                                    <div class="desc">
                                        <p>07522140 单片机原理与技术 <br>英文名称：Principle and Technology of Single-Chip Microcomputer <br>学分：4 <br>适用专业：物联网工程 <br>预修课程：数字电路、C语言程序设计 <br>内容简介： 本课程是物联网工程专业学生的一门专业必修课。通过本课程的学习使学生掌握计算机的一个重要分支--单片机的结构、原理和应用技术。要求学生掌握单片机的内部组织、工作原理、存储结构、I/O端口、定时器/计数器、中断、串行通信等功能部件的原理及使用方法，掌握并行接口、键盘、显示器、A/D转换、D/A转换等功能部件的扩展和应用技术，同时，通过本课程的学习是学生掌握单片机的汇编语言和C语言编程。本课程学习后能够进行基于单片机的数据采集、控制及通讯系统的设计与开发，为单片机应用打下坚实的基础。</p>
                                    </div>
                                    <a href="../teaching_plan/C_Teaching_Plan_Outline.html" class="link">Read More</a>
                                </div>
                            </div>
                            <!-- Single Blog End -->
                        </div>
                        
                        <div class="col-lg-6 col-md-6">
                            <!-- Single Blog start -->
                            <div class="single-blog mt-30" style="margin-left: 30px;">
                                
                                <div class="blog-content">
                                    <h5 class="title"><a >课程通知</a></h5>

                                    <?php
                                    while($row = mysqli_fetch_assoc($result)) {     //mysqli_fetch_assoc()从结果集中取数据
                                        if($row['father'] == $get_course) {
                                            echo '   <ul class="meta">';
                                            echo '<li><i class="fa fa-calendar"></i>'.$row['date'].'</li>';
                                            echo '<li><a href="../notice/notice_content.php?name='.$row['name'].'">'.$row['name'].'</a></li>';
//                                            <li><i class="fa fa-user-circle"></i>Posts by:admin</li>
                                    // 暂无发布人 以后再实现老师权限
                                    echo ' </ul>';
                                        }
                                    }
                                    // 释放结果集
                                    mysqli_free_result($result);
                                    // 关闭连接
                                    mysqli_close($connection);
                                    ?>

                                    <a href="../notice/notice.php" class="link">Read More</a>
                                </div>
                            </div>
                            <!-- Single Blog End -->
                        </div>
                        
                        
                       
                    </div>
                    
                </div>
                <div class="col-lg-3 order-lg-1">
                    <div class="widget-sidebar margin-blog">
                        <!-- <div class="widget-search">
                            <div class="sidebar-title">
                                <h4 class="title-shop">C语言程序设计</h4>
                            </div>
                            <div class="category-search">
                                <input class="search-hear" placeholder="Search......" type="text">
                                <a class="srch-btn" href="#"><i class="zmdi zmdi-search"></i></a>
                            </div>
                        </div> -->
                        <div class="widget-thumb mt-30">
                            <div class="sidebar-title">
                                <h4 class="title-shop">课程内容</h4>
                            </div>
                            <div class="thumb-wrapper">
                                <!-- Single Blog Thumb Start -->
                                <div class="single-blog-thumb d-flex">
                                    
                                    <div class="blog-info">
                                        <h5 class="info-title"><a href="../teaching_plan/College_Computer_Teaching_Plan_Plan.html">教学计划</a></h5>
                                        
                                    </div>
                                </div>
                                <!-- Single Blog Thumb End -->
                                <!-- Single Blog Thumb Start -->
                                <div class="single-blog-thumb d-flex">
                                    
                                    <div class="blog-info">
                                        <h5 class="info-title"><a href="../instruct/instruct_大学计算机.html">教学指导</a></h5>
                                        
                                    </div>
                                </div>
                                <!-- Single Blog Thumb End -->
                                <!-- Single Blog Thumb Start -->
                                <div class="single-blog-thumb d-flex">
                                    
                                    <div class="blog-info">
                                        <h5 class="info-title"><a href="../resource/computer/resource_com.php">教学资源</a></h5>
                                       
                                    </div>
                                </div>
                                <!-- Single Blog Thumb End -->
                                <!-- Single Blog Thumb Start -->
                                
                                <!-- Single Blog Thumb End -->
                            </div>
                        </div><div class="widget-thumb mt-30">
                            <div class="sidebar-title">
                                <h4 class="title-shop">在线系统</h4>
                            </div>
                            <div class="thumb-wrapper">
                                <!-- Single Blog Thumb Start -->
                                <div class="single-blog-thumb d-flex">
                                    
                                    <div class="blog-info">
                                        <h5 class="info-title"><a href="#">在线练习系统</a></h5>
                                        
                                    </div>
                                </div>
                                <!-- Single Blog Thumb End -->
                                <!-- Single Blog Thumb Start -->
                                <div class="single-blog-thumb d-flex">
                                   
                                    <div class="blog-info">
                                        <h5 class="info-title"><a href="#">在线考试系统</a></h5>    
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div><div class="widget-thumb mt-30">
                        <div class="sidebar-title">
                            <h4 class="title-shop">常见问题</h4>
                        </div>
                        <div class="thumb-wrapper">
                            <!-- Single Blog Thumb Start -->
                            <div class="single-blog-thumb d-flex">
                                
                                <div class="blog-info">
                                    <h5 class="info-title"><a href="../question/大学计算机常见问题.html">常见问题</a></h5>
                                    
                                </div>
                            </div>
                            
                        </div>
                    </div>
                        
                       
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!--=====================
        Blog Grid Aera End
    =========================-->

    <!--===================
     footer area start 
    ===================-->
    <footer class="mt-30">
       
        <!-- Footer Bottom Start -->
        <div class="footer-bottom">
            <div class="container">
                <div class="row align-items-center">
                    <div class="col-lg-5 col-md-12 col-12">
                        <div class="footer-bottom-content">
                            <div class="footer-copyright">
                                <p>Copyright &copy; 2020.Company name All rights reserved.</p>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <!-- Footer Bottom End -->
    </footer>
    <!--===================
     footer area end 
    ===================-->

    <!-- Scroll To Top Start -->
    <a class="scroll-to-top" href=""><i class="fa fa-angle-up"></i></a>
    <!-- Scroll To Top End -->


    <!-- Use the minified version files listed below for better performance and remove the files listed above -->
    <script src="../assets/js/vendor/vendor.min.js"></script>
    <script src="../assets/js/plugins/plugins.min.js"></script>

    <!-- Main JS -->
    <script src="../assets/js/main.js"></script>

</body>

</html>
